#!/usr/bin/env python3
import pandas as pd

df = pd.read_excel(r'D:\MyPython\PlayTogether_Data\book3_pandas\class13_index_series'
    '\house.xlsx', usecols=[1, 3, 6, 7, 8], index_col = 0, engine='openpyxl')
df[0]   # 报错，dataframe结构，不支持下标
df['总价']
type(df)    # DataFrame
price = df['总价']
type(price)    # Series对象
price
price[101101885869]
price[0]    # 报错：数值型，查无此值
price.values
price.values / 7
price.index = [ str(i) for i in price.index ]
price[0]